﻿using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using ConsolidationTool.Common.Entities;
using System.Collections.Generic;
using ConsolidationTool.Common;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using ConsolidationTool.WebParts.ControlTemplates;

namespace ConsolidationTool.WebParts.Layouts.CReport.Flash
{
    public partial class HR : FSReportBase
    {
        public override ControlTemplates.CommonEntitySelector TopSelector
        {
            get
            {
                return commonEntitySelector as ControlTemplates.CommonEntitySelector;
            }
        }

        public override void BeforLoad()
        {
            if (!IsPostBack)
            {
                InitBaseInfo();
            }
        }

        void TopSelector_EntitySelectorChanged(object sender, int EntityID)
        {


        }

        void InitBaseInfo()
        {
            if (!Automatic)
            {
                TopSelector.yearTextBox.Text = Common.BusinessService.GetConfiguration(Constants.Flash_Input_Year);
                TopSelector.monthTextBox.Text = Common.BusinessService.GetConfiguration(Constants.Flash_Input_Month);
            }

            Title_HRM1.Text = TopSelector.yearTextBox.Text + ".01";
            Title_HRM2.Text = TopSelector.yearTextBox.Text + ".02";
            Title_HRM3.Text = TopSelector.yearTextBox.Text + ".03";
            Title_HRM4.Text = TopSelector.yearTextBox.Text + ".04";
            Title_HRM5.Text = TopSelector.yearTextBox.Text + ".05";
            Title_HRM6.Text = TopSelector.yearTextBox.Text + ".06";
            Title_HRM7.Text = TopSelector.yearTextBox.Text + ".07";
            Title_HRM8.Text = TopSelector.yearTextBox.Text + ".08";
            Title_HRM9.Text = TopSelector.yearTextBox.Text + ".09";
            Title_HRM10.Text = TopSelector.yearTextBox.Text + ".10";
            Title_HRM11.Text = TopSelector.yearTextBox.Text + ".11";
            Title_HRM12.Text = TopSelector.yearTextBox.Text + ".12";
        }

        public override void GenerateReport_Click(object sender, EventArgs e)
        {
            Title_HRM1.Text = TopSelector.yearTextBox.Text + ".01";
            Title_HRM2.Text = TopSelector.yearTextBox.Text + ".02";
            Title_HRM3.Text = TopSelector.yearTextBox.Text + ".03";
            Title_HRM4.Text = TopSelector.yearTextBox.Text + ".04";
            Title_HRM5.Text = TopSelector.yearTextBox.Text + ".05";
            Title_HRM6.Text = TopSelector.yearTextBox.Text + ".06";
            Title_HRM7.Text = TopSelector.yearTextBox.Text + ".07";
            Title_HRM8.Text = TopSelector.yearTextBox.Text + ".08";
            Title_HRM9.Text = TopSelector.yearTextBox.Text + ".09";
            Title_HRM10.Text = TopSelector.yearTextBox.Text + ".10";
            Title_HRM11.Text = TopSelector.yearTextBox.Text + ".11";
            Title_HRM12.Text = TopSelector.yearTextBox.Text + ".12";

            //邦定current月数据
            int m = Convert.ToInt32(TopSelector.monthTextBox.Text);

            for (int i = 1; i <= m; i++)
            {
                string strMonth = i.ToString();
                BindLastMonth(TopSelector.lbCoCd.Text, TopSelector.yearTextBox.Text, strMonth);
            }

        }

        protected void ExportReport_Click(object sender, EventArgs e)
        {
            P6PL col01 = null;
            col01 = new P6PL();
            col01.row01 = Label_HRR01_C01.Text;
            col01.row02 = Label_HRR02_C01.Text;
            col01.row03 = Label_HRR03_C01.Text;
            col01.row04 = Label_HRR04_C01.Text;
            col01.row05 = Label_HRR05_C01.Text;
            col01.row06 = Label_HRR06_C01.Text;
            col01.row07 = Label_HRR07_C01.Text;
            col01.row08 = Label_HRR08_C01.Text;
            col01.row09 = Label_HRR09_C01.Text;
            col01.row10 = Label_HRR10_C01.Text;
            col01.row12 = Label_HRR12_C01.Text;
            col01.row13 = Label_HRR13_C01.Text;
            col01.row14 = Label_HRR14_C01.Text;
            col01.row15 = Label_HRR15_C01.Text;
            col01.row16 = Label_HRR16_C01.Text;
            col01.row17 = Label_HRR17_C01.Text;
            col01.row18 = Label_HRR18_C01.Text;
            col01.row19 = Label_HRR19_C01.Text;
            col01.row20 = Label_HRR20_C01.Text;
            col01.row21 = Label_HRR21_C01.Text;
            col01.row22 = Label_HRR22_C01.Text;
            col01.row23 = Label_HRR23_C01.Text;
            col01.row24 = Label_HRR24_C01.Text;
            col01.row25 = Label_HRR25_C01.Text;
            col01.row26 = Label_HRR26_C01.Text;
            col01.row27 = Label_HRR27_C01.Text;
            col01.row28 = Label_HRR28_C01.Text;
            col01.row29 = Label_HRR29_C01.Text;
            col01.row30 = Label_HRR30_C01.Text;
            col01.row31 = Label_HRR31_C01.Text;
            col01.row32 = Label_HRR32_C01.Text;
            col01.row33 = Label_HRR33_C01.Text;
            col01.row34 = Label_HRR34_C01.Text;
            col01.row35 = Label_HRR35_C01.Text;

            P6PL col02 = null;
            col02 = new P6PL();
            col02.row01 = Label_HRR01_C02.Text;
            col02.row02 = Label_HRR02_C02.Text;
            col02.row03 = Label_HRR03_C02.Text;
            col02.row04 = Label_HRR04_C02.Text;
            col02.row05 = Label_HRR05_C02.Text;
            col02.row06 = Label_HRR06_C02.Text;
            col02.row07 = Label_HRR07_C02.Text;
            col02.row08 = Label_HRR08_C02.Text;
            col02.row09 = Label_HRR09_C02.Text;
            col02.row10 = Label_HRR10_C02.Text;
            col02.row12 = Label_HRR12_C02.Text;
            col02.row13 = Label_HRR13_C02.Text;
            col02.row14 = Label_HRR14_C02.Text;
            col02.row15 = Label_HRR15_C02.Text;
            col02.row16 = Label_HRR16_C02.Text;
            col02.row17 = Label_HRR17_C02.Text;
            col02.row18 = Label_HRR18_C02.Text;
            col02.row19 = Label_HRR19_C02.Text;
            col02.row20 = Label_HRR20_C02.Text;
            col02.row21 = Label_HRR21_C02.Text;
            col02.row22 = Label_HRR22_C02.Text;
            col02.row23 = Label_HRR23_C02.Text;
            col02.row24 = Label_HRR24_C02.Text;
            col02.row25 = Label_HRR25_C02.Text;
            col02.row26 = Label_HRR26_C02.Text;
            col02.row27 = Label_HRR27_C02.Text;
            col02.row28 = Label_HRR28_C02.Text;
            col02.row29 = Label_HRR29_C02.Text;
            col02.row30 = Label_HRR30_C02.Text;
            col02.row31 = Label_HRR31_C02.Text;
            col02.row32 = Label_HRR32_C02.Text;
            col02.row33 = Label_HRR33_C02.Text;
            col02.row34 = Label_HRR34_C02.Text;
            col02.row35 = Label_HRR35_C02.Text;

            P6PL col03 = null;
            col03 = new P6PL();
            col03.row01 = Label_HRR01_C03.Text;
            col03.row02 = Label_HRR02_C03.Text;
            col03.row03 = Label_HRR03_C03.Text;
            col03.row04 = Label_HRR04_C03.Text;
            col03.row05 = Label_HRR05_C03.Text;
            col03.row06 = Label_HRR06_C03.Text;
            col03.row07 = Label_HRR07_C03.Text;
            col03.row08 = Label_HRR08_C03.Text;
            col03.row09 = Label_HRR09_C03.Text;
            col03.row10 = Label_HRR10_C03.Text;
            col03.row12 = Label_HRR12_C03.Text;
            col03.row13 = Label_HRR13_C03.Text;
            col03.row14 = Label_HRR14_C03.Text;
            col03.row15 = Label_HRR15_C03.Text;
            col03.row16 = Label_HRR16_C03.Text;
            col03.row17 = Label_HRR17_C03.Text;
            col03.row18 = Label_HRR18_C03.Text;
            col03.row19 = Label_HRR19_C03.Text;
            col03.row20 = Label_HRR20_C03.Text;
            col03.row21 = Label_HRR21_C03.Text;
            col03.row22 = Label_HRR22_C03.Text;
            col03.row23 = Label_HRR23_C03.Text;
            col03.row24 = Label_HRR24_C03.Text;
            col03.row25 = Label_HRR25_C03.Text;
            col03.row26 = Label_HRR26_C03.Text;
            col03.row27 = Label_HRR27_C03.Text;
            col03.row28 = Label_HRR28_C03.Text;
            col03.row29 = Label_HRR29_C03.Text;
            col03.row30 = Label_HRR30_C03.Text;
            col03.row31 = Label_HRR31_C03.Text;
            col03.row32 = Label_HRR32_C03.Text;
            col03.row33 = Label_HRR33_C03.Text;
            col03.row34 = Label_HRR34_C03.Text;
            col03.row35 = Label_HRR35_C03.Text;

            P6PL col04 = null;
            col04 = new P6PL();
            col04.row01 = Label_HRR01_C04.Text;
            col04.row02 = Label_HRR02_C04.Text;
            col04.row03 = Label_HRR03_C04.Text;
            col04.row04 = Label_HRR04_C04.Text;
            col04.row05 = Label_HRR05_C04.Text;
            col04.row06 = Label_HRR06_C04.Text;
            col04.row07 = Label_HRR07_C04.Text;
            col04.row08 = Label_HRR08_C04.Text;
            col04.row09 = Label_HRR09_C04.Text;
            col04.row10 = Label_HRR10_C04.Text;
            col04.row12 = Label_HRR12_C04.Text;
            col04.row13 = Label_HRR13_C04.Text;
            col04.row14 = Label_HRR14_C04.Text;
            col04.row15 = Label_HRR15_C04.Text;
            col04.row16 = Label_HRR16_C04.Text;
            col04.row17 = Label_HRR17_C04.Text;
            col04.row18 = Label_HRR18_C04.Text;
            col04.row19 = Label_HRR19_C04.Text;
            col04.row20 = Label_HRR20_C04.Text;
            col04.row21 = Label_HRR21_C04.Text;
            col04.row22 = Label_HRR22_C04.Text;
            col04.row23 = Label_HRR23_C04.Text;
            col04.row24 = Label_HRR24_C04.Text;
            col04.row25 = Label_HRR25_C04.Text;
            col04.row26 = Label_HRR26_C04.Text;
            col04.row27 = Label_HRR27_C04.Text;
            col04.row28 = Label_HRR28_C04.Text;
            col04.row29 = Label_HRR29_C04.Text;
            col04.row30 = Label_HRR30_C04.Text;
            col04.row31 = Label_HRR31_C04.Text;
            col04.row32 = Label_HRR32_C04.Text;
            col04.row33 = Label_HRR33_C04.Text;
            col04.row34 = Label_HRR34_C04.Text;

            P6PL col05 = null;
            col05 = new P6PL();
            col05.row01 = Label_HRR01_C05.Text;
            col05.row02 = Label_HRR02_C05.Text;
            col05.row03 = Label_HRR03_C05.Text;
            col05.row04 = Label_HRR04_C05.Text;
            col05.row05 = Label_HRR05_C05.Text;
            col05.row06 = Label_HRR06_C05.Text;
            col05.row07 = Label_HRR07_C05.Text;
            col05.row08 = Label_HRR08_C05.Text;
            col05.row09 = Label_HRR09_C05.Text;
            col05.row10 = Label_HRR10_C05.Text;
            col05.row12 = Label_HRR12_C05.Text;
            col05.row13 = Label_HRR13_C05.Text;
            col05.row14 = Label_HRR14_C05.Text;
            col05.row15 = Label_HRR15_C05.Text;
            col05.row16 = Label_HRR16_C05.Text;
            col05.row17 = Label_HRR17_C05.Text;
            col05.row18 = Label_HRR18_C05.Text;
            col05.row19 = Label_HRR19_C05.Text;
            col05.row20 = Label_HRR20_C05.Text;
            col05.row21 = Label_HRR21_C05.Text;
            col05.row22 = Label_HRR22_C05.Text;
            col05.row23 = Label_HRR23_C05.Text;
            col05.row24 = Label_HRR24_C05.Text;
            col05.row25 = Label_HRR25_C05.Text;
            col05.row26 = Label_HRR26_C05.Text;
            col05.row27 = Label_HRR27_C05.Text;
            col05.row28 = Label_HRR28_C05.Text;
            col05.row29 = Label_HRR29_C05.Text;
            col05.row30 = Label_HRR30_C05.Text;
            col05.row31 = Label_HRR31_C05.Text;
            col05.row32 = Label_HRR32_C05.Text;
            col05.row33 = Label_HRR33_C05.Text;
            col05.row34 = Label_HRR34_C05.Text;
            col05.row35 = Label_HRR35_C05.Text;

            P6PL col06 = null;
            col06 = new P6PL();
            col06.row01 = Label_HRR01_C06.Text;
            col06.row02 = Label_HRR02_C06.Text;
            col06.row03 = Label_HRR03_C06.Text;
            col06.row04 = Label_HRR04_C06.Text;
            col06.row05 = Label_HRR05_C06.Text;
            col06.row06 = Label_HRR06_C06.Text;
            col06.row07 = Label_HRR07_C06.Text;
            col06.row08 = Label_HRR08_C06.Text;
            col06.row09 = Label_HRR09_C06.Text;
            col06.row10 = Label_HRR10_C06.Text;
            col06.row12 = Label_HRR12_C06.Text;
            col06.row13 = Label_HRR13_C06.Text;
            col06.row14 = Label_HRR14_C06.Text;
            col06.row15 = Label_HRR15_C06.Text;
            col06.row16 = Label_HRR16_C06.Text;
            col06.row17 = Label_HRR17_C06.Text;
            col06.row18 = Label_HRR18_C06.Text;
            col06.row19 = Label_HRR19_C06.Text;
            col06.row20 = Label_HRR20_C06.Text;
            col06.row21 = Label_HRR21_C06.Text;
            col06.row22 = Label_HRR22_C06.Text;
            col06.row23 = Label_HRR23_C06.Text;
            col06.row24 = Label_HRR24_C06.Text;
            col06.row25 = Label_HRR25_C06.Text;
            col06.row26 = Label_HRR26_C06.Text;
            col06.row27 = Label_HRR27_C06.Text;
            col06.row28 = Label_HRR28_C06.Text;
            col06.row29 = Label_HRR29_C06.Text;
            col06.row30 = Label_HRR30_C06.Text;
            col06.row31 = Label_HRR31_C06.Text;
            col06.row32 = Label_HRR32_C06.Text;
            col06.row33 = Label_HRR33_C06.Text;
            col06.row34 = Label_HRR34_C06.Text;
            col06.row35 = Label_HRR35_C06.Text;

            P6PL col07 = null;
            col07 = new P6PL();
            col07.row01 = Label_HRR01_C07.Text;
            col07.row02 = Label_HRR02_C07.Text;
            col07.row03 = Label_HRR03_C07.Text;
            col07.row04 = Label_HRR04_C07.Text;
            col07.row05 = Label_HRR05_C07.Text;
            col07.row06 = Label_HRR06_C07.Text;
            col07.row07 = Label_HRR07_C07.Text;
            col07.row08 = Label_HRR08_C07.Text;
            col07.row09 = Label_HRR09_C07.Text;
            col07.row10 = Label_HRR10_C07.Text;
            col07.row12 = Label_HRR12_C07.Text;
            col07.row13 = Label_HRR13_C07.Text;
            col07.row14 = Label_HRR14_C07.Text;
            col07.row15 = Label_HRR15_C07.Text;
            col07.row16 = Label_HRR16_C07.Text;
            col07.row17 = Label_HRR17_C07.Text;
            col07.row18 = Label_HRR18_C07.Text;
            col07.row19 = Label_HRR19_C07.Text;
            col07.row20 = Label_HRR20_C07.Text;
            col07.row21 = Label_HRR21_C07.Text;
            col07.row22 = Label_HRR22_C07.Text;
            col07.row23 = Label_HRR23_C07.Text;
            col07.row24 = Label_HRR24_C07.Text;
            col07.row25 = Label_HRR25_C07.Text;
            col07.row26 = Label_HRR26_C07.Text;
            col07.row27 = Label_HRR27_C07.Text;
            col07.row28 = Label_HRR28_C07.Text;
            col07.row29 = Label_HRR29_C07.Text;
            col07.row30 = Label_HRR30_C07.Text;
            col07.row31 = Label_HRR31_C07.Text;
            col07.row32 = Label_HRR32_C07.Text;
            col07.row33 = Label_HRR33_C07.Text;
            col07.row34 = Label_HRR34_C07.Text;
            col07.row35 = Label_HRR35_C07.Text;

            P6PL col08 = null;
            col08 = new P6PL();
            col08.row01 = Label_HRR01_C08.Text;
            col08.row02 = Label_HRR02_C08.Text;
            col08.row03 = Label_HRR03_C08.Text;
            col08.row04 = Label_HRR04_C08.Text;
            col08.row05 = Label_HRR05_C08.Text;
            col08.row06 = Label_HRR06_C08.Text;
            col08.row07 = Label_HRR07_C08.Text;
            col08.row08 = Label_HRR08_C08.Text;
            col08.row09 = Label_HRR09_C08.Text;
            col08.row10 = Label_HRR10_C08.Text;
            col08.row12 = Label_HRR12_C08.Text;
            col08.row13 = Label_HRR13_C08.Text;
            col08.row14 = Label_HRR14_C08.Text;
            col08.row15 = Label_HRR15_C08.Text;
            col08.row16 = Label_HRR16_C08.Text;
            col08.row17 = Label_HRR17_C08.Text;
            col08.row18 = Label_HRR18_C08.Text;
            col08.row19 = Label_HRR19_C08.Text;
            col08.row20 = Label_HRR20_C08.Text;
            col08.row21 = Label_HRR21_C08.Text;
            col08.row22 = Label_HRR22_C08.Text;
            col08.row23 = Label_HRR23_C08.Text;
            col08.row24 = Label_HRR24_C08.Text;
            col08.row25 = Label_HRR25_C08.Text;
            col08.row26 = Label_HRR26_C08.Text;
            col08.row27 = Label_HRR27_C08.Text;
            col08.row28 = Label_HRR28_C08.Text;
            col08.row29 = Label_HRR29_C08.Text;
            col08.row30 = Label_HRR30_C08.Text;
            col08.row31 = Label_HRR31_C08.Text;
            col08.row32 = Label_HRR32_C08.Text;
            col08.row33 = Label_HRR33_C08.Text;
            col08.row34 = Label_HRR34_C08.Text;
            col08.row35 = Label_HRR35_C08.Text;

            P6PL col09 = null;
            col09 = new P6PL();
            col09.row01 = Label_HRR01_C09.Text;
            col09.row02 = Label_HRR02_C09.Text;
            col09.row03 = Label_HRR03_C09.Text;
            col09.row04 = Label_HRR04_C09.Text;
            col09.row05 = Label_HRR05_C09.Text;
            col09.row06 = Label_HRR06_C09.Text;
            col09.row07 = Label_HRR07_C09.Text;
            col09.row08 = Label_HRR08_C09.Text;
            col09.row09 = Label_HRR09_C09.Text;
            col09.row10 = Label_HRR10_C09.Text;
            col09.row12 = Label_HRR12_C09.Text;
            col09.row13 = Label_HRR13_C09.Text;
            col09.row14 = Label_HRR14_C09.Text;
            col09.row15 = Label_HRR15_C09.Text;
            col09.row16 = Label_HRR16_C09.Text;
            col09.row17 = Label_HRR17_C09.Text;
            col09.row18 = Label_HRR18_C09.Text;
            col09.row19 = Label_HRR19_C09.Text;
            col09.row20 = Label_HRR20_C09.Text;
            col09.row21 = Label_HRR21_C09.Text;
            col09.row22 = Label_HRR22_C09.Text;
            col09.row23 = Label_HRR23_C09.Text;
            col09.row24 = Label_HRR24_C09.Text;
            col09.row25 = Label_HRR25_C09.Text;
            col09.row26 = Label_HRR26_C09.Text;
            col09.row27 = Label_HRR27_C09.Text;
            col09.row28 = Label_HRR28_C09.Text;
            col09.row29 = Label_HRR29_C09.Text;
            col09.row30 = Label_HRR30_C09.Text;
            col09.row31 = Label_HRR31_C09.Text;
            col09.row32 = Label_HRR32_C09.Text;
            col09.row33 = Label_HRR33_C09.Text;
            col09.row34 = Label_HRR34_C09.Text;
            col09.row35 = Label_HRR35_C09.Text;

            P6PL col10 = null;
            col10 = new P6PL();
            col10.row01 = Label_HRR01_C10.Text;
            col10.row02 = Label_HRR02_C10.Text;
            col10.row03 = Label_HRR03_C10.Text;
            col10.row04 = Label_HRR04_C10.Text;
            col10.row05 = Label_HRR05_C10.Text;
            col10.row06 = Label_HRR06_C10.Text;
            col10.row07 = Label_HRR07_C10.Text;
            col10.row08 = Label_HRR08_C10.Text;
            col10.row09 = Label_HRR09_C10.Text;
            col10.row10 = Label_HRR10_C10.Text;
            col10.row12 = Label_HRR12_C10.Text;
            col10.row13 = Label_HRR13_C10.Text;
            col10.row14 = Label_HRR14_C10.Text;
            col10.row15 = Label_HRR15_C10.Text;
            col10.row16 = Label_HRR16_C10.Text;
            col10.row17 = Label_HRR17_C10.Text;
            col10.row18 = Label_HRR18_C10.Text;
            col10.row19 = Label_HRR19_C10.Text;
            col10.row20 = Label_HRR20_C10.Text;
            col10.row21 = Label_HRR21_C10.Text;
            col10.row22 = Label_HRR22_C10.Text;
            col10.row23 = Label_HRR23_C10.Text;
            col10.row24 = Label_HRR24_C10.Text;
            col10.row25 = Label_HRR25_C10.Text;
            col10.row26 = Label_HRR26_C10.Text;
            col10.row27 = Label_HRR27_C10.Text;
            col10.row28 = Label_HRR28_C10.Text;
            col10.row29 = Label_HRR29_C10.Text;
            col10.row30 = Label_HRR30_C10.Text;
            col10.row31 = Label_HRR31_C10.Text;
            col10.row32 = Label_HRR32_C10.Text;
            col10.row33 = Label_HRR33_C10.Text;
            col10.row34 = Label_HRR34_C10.Text;
            col10.row35 = Label_HRR35_C10.Text;

            P6PL col11 = null;
            col11 = new P6PL();
            col11.row01 = Label_HRR01_C11.Text;
            col11.row02 = Label_HRR02_C11.Text;
            col11.row03 = Label_HRR03_C11.Text;
            col11.row04 = Label_HRR04_C11.Text;
            col11.row05 = Label_HRR05_C11.Text;
            col11.row06 = Label_HRR06_C11.Text;
            col11.row07 = Label_HRR07_C11.Text;
            col11.row08 = Label_HRR08_C11.Text;
            col11.row09 = Label_HRR09_C11.Text;
            col11.row10 = Label_HRR10_C11.Text;
            col11.row12 = Label_HRR12_C11.Text;
            col11.row13 = Label_HRR13_C11.Text;
            col11.row14 = Label_HRR14_C11.Text;
            col11.row15 = Label_HRR15_C11.Text;
            col11.row16 = Label_HRR16_C11.Text;
            col11.row17 = Label_HRR17_C11.Text;
            col11.row18 = Label_HRR18_C11.Text;
            col11.row19 = Label_HRR19_C11.Text;
            col11.row20 = Label_HRR20_C11.Text;
            col11.row21 = Label_HRR21_C11.Text;
            col11.row22 = Label_HRR22_C11.Text;
            col11.row23 = Label_HRR23_C11.Text;
            col11.row24 = Label_HRR24_C11.Text;
            col11.row25 = Label_HRR25_C11.Text;
            col11.row26 = Label_HRR26_C11.Text;
            col11.row27 = Label_HRR27_C11.Text;
            col11.row28 = Label_HRR28_C11.Text;
            col11.row29 = Label_HRR29_C11.Text;
            col11.row30 = Label_HRR30_C11.Text;
            col11.row31 = Label_HRR31_C11.Text;
            col11.row32 = Label_HRR32_C11.Text;
            col11.row33 = Label_HRR33_C11.Text;
            col11.row34 = Label_HRR34_C11.Text;
            col11.row35 = Label_HRR35_C11.Text;

            P6PL col12 = null;
            col12 = new P6PL();
            col12.row01 = Label_HRR01_C12.Text;
            col12.row02 = Label_HRR02_C12.Text;
            col12.row03 = Label_HRR03_C12.Text;
            col12.row04 = Label_HRR04_C12.Text;
            col12.row05 = Label_HRR05_C12.Text;
            col12.row06 = Label_HRR06_C12.Text;
            col12.row07 = Label_HRR07_C12.Text;
            col12.row08 = Label_HRR08_C12.Text;
            col12.row09 = Label_HRR09_C12.Text;
            col12.row10 = Label_HRR10_C12.Text;
            col12.row12 = Label_HRR12_C12.Text;
            col12.row13 = Label_HRR13_C12.Text;
            col12.row14 = Label_HRR14_C12.Text;
            col12.row15 = Label_HRR15_C12.Text;
            col12.row16 = Label_HRR16_C12.Text;
            col12.row17 = Label_HRR17_C12.Text;
            col12.row18 = Label_HRR18_C12.Text;
            col12.row19 = Label_HRR19_C12.Text;
            col12.row20 = Label_HRR20_C12.Text;
            col12.row21 = Label_HRR21_C12.Text;
            col12.row22 = Label_HRR22_C12.Text;
            col12.row23 = Label_HRR23_C12.Text;
            col12.row24 = Label_HRR24_C12.Text;
            col12.row25 = Label_HRR25_C12.Text;
            col12.row26 = Label_HRR26_C12.Text;
            col12.row27 = Label_HRR27_C12.Text;
            col12.row28 = Label_HRR28_C12.Text;
            col12.row29 = Label_HRR29_C12.Text;
            col12.row30 = Label_HRR30_C12.Text;
            col12.row31 = Label_HRR31_C12.Text;
            col12.row32 = Label_HRR32_C12.Text;
            col12.row33 = Label_HRR33_C12.Text;
            col12.row34 = Label_HRR34_C12.Text;
            col12.row35 = Label_HRR35_C12.Text;

            P6PL col00 = null;
            col00 = new P6PL();
            col00.row01 = "HR01010100";
            col00.row02 = "HR01010101";
            col00.row03 = "HR01010102";
            col00.row04 = "HR01010103";
            col00.row05 = "HR01010104";
            col00.row06 = "HR01010105";
            col00.row07 = "HR01010106";
            col00.row08 = "HR01010200";
            col00.row09 = "HR01010301";
            col00.row10 = "HR01010302";
            col00.row12 = "HR01020100";
            col00.row13 = "HR01020101";
            col00.row14 = "HR01020102";
            col00.row15 = "HR01020103";
            col00.row16 = "HR01020104";
            col00.row17 = "HR01020105";
            col00.row18 = "HR01020106";
            col00.row19 = "HR01020200";
            col00.row35 = "HR01020300";
            col00.row20 = "HR01030101";
            col00.row21 = "HR01030102";
            col00.row22 = "HR01030100";
            col00.row23 = "HR01040101";
            col00.row24 = "HR01040102";
            col00.row25 = "HR01040100";
            col00.row26 = "HR01050100";
            col00.row27 = "HR01060100";
            col00.row28 = "HR01060101";
            col00.row29 = "HR01060102";
            col00.row30 = "HR01070100";
            col00.row31 = "HR01070101";
            col00.row32 = "HR01070102";
            col00.row33 = "HR01080100";
            col00.row34 = "HR01090100";


            P6PL colHead = null;
            colHead = new P6PL();
            colHead.row01 = TopSelector.drpRegion.Text;
            colHead.row02 = TopSelector.drpSubRegion.Text;
            colHead.row03 = TopSelector.lbCompanyFullName.Text;
            colHead.row04 = TopSelector.lbCoCd.Text;
            colHead.row05 = TopSelector.lbCompanyFullName.Text;
            colHead.row06 = TopSelector.yearTextBox.Text;
            colHead.row07 = TopSelector.monthTextBox.Text;
            colHead.row08 = TopSelector.lbCompanyCurrency.Text;
            colHead.row09 = TopSelector.lbCompanyTonnage.Text;
            colHead.row11 = Title_HRM1.Text;
            colHead.row12 = Title_HRM2.Text;
            colHead.row13 = Title_HRM3.Text;
            colHead.row14 = Title_HRM4.Text;
            colHead.row15 = Title_HRM5.Text;
            colHead.row16 = Title_HRM6.Text;
            colHead.row17 = Title_HRM7.Text;
            colHead.row18 = Title_HRM8.Text;
            colHead.row19 = Title_HRM9.Text;
            colHead.row20 = Title_HRM10.Text;
            colHead.row21 = Title_HRM11.Text;
            colHead.row22 = Title_HRM12.Text;

            string fileName = TopSelector.yearTextBox.Text + TopSelector.monthTextBox.Text + Constants._ReportTemplate_FlashHR + TopSelector.lbCoCd.Text + ".xlsx";
            BusinessService.CreateHRExcel(col00, col01, col02, col03, col04, col05, col06, col07, col08, col09, col10, col11, col12, fileName, colHead);
            SPSite site = new SPSite(SPContext.Current.Site.ID);
            string reportUrl = site.Url + "/" + Constants._EXCEL_Library + "/" + fileName;
            Page.ClientScript.RegisterStartupScript(this.GetType(), "Message", string.Format("<script>window.open('" + reportUrl + "');</script>"));

        }

        void BindLastMonth(string coCd, string year, string month)
        {
            string y = year;
            string m = (Convert.ToInt32(month)).ToString();
            SPListItem it = Common.BusinessService.GetItem(coCd, y, m, "HR");

            if (it != null)
            {
                switch (m)
                {
                    case "1":
                        Label_HRR01_C01.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C01.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C01.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C01.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C01.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C01.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C01.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C01.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C01.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C01.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C01.Text = HRRation.ToString("p");
                        Label_HRR12_C01.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C01.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C01.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C01.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C01.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C01.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C01.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C01.Text = BusinessService.decimalParse( Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");

                        Label_HRR20_C01.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C01.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C01.Text = Common.Utilities.GetItemValue(it, "HR01030100");

                        Label_HRR23_C01.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C01.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C01.Text = Common.Utilities.GetItemValue(it, "HR01040100");

                        Label_HRR26_C01.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C01.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C01.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C01.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C01.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C01.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C01.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C01.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C01.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C01.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    case "2":
                        Label_HRR01_C02.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C02.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C02.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C02.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C02.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C02.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C02.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C02.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C02.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C02.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation2 = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C02.Text = HRRation2.ToString("p");
                        Label_HRR12_C02.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C02.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C02.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C02.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C02.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C02.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C02.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C02.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");

                        Label_HRR20_C02.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C02.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C02.Text = Common.Utilities.GetItemValue(it, "HR01030100");
                        Label_HRR23_C02.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C02.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C02.Text = Common.Utilities.GetItemValue(it, "HR01040100");

                        Label_HRR26_C02.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C02.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C02.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C02.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C02.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C02.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C02.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C02.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C02.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C02.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    case "3":
                        Label_HRR01_C03.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C03.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C03.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C03.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C03.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C03.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C03.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C03.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C03.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C03.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation3 = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C03.Text = HRRation3.ToString("p");
                        Label_HRR12_C03.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C03.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C03.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C03.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C03.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C03.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C03.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C03.Text = BusinessService.decimalParse( Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");

                        Label_HRR20_C03.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C03.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C03.Text = Common.Utilities.GetItemValue(it, "HR01030100");
                        Label_HRR23_C03.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C03.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C03.Text = Common.Utilities.GetItemValue(it, "HR01040100");

                        Label_HRR26_C03.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C03.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C03.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C03.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C03.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C03.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C03.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C03.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C03.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C03.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    case "4":
                        Label_HRR01_C04.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C04.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C04.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C04.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C04.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C04.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C04.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C04.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C04.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C04.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation4 = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C04.Text = HRRation4.ToString("p");
                        Label_HRR12_C04.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C04.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C04.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C04.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C04.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C04.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C04.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C04.Text = BusinessService.decimalParse( Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");

                        Label_HRR20_C04.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C04.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C04.Text = Common.Utilities.GetItemValue(it, "HR01030100");
                        Label_HRR23_C04.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C04.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C04.Text = Common.Utilities.GetItemValue(it, "HR01040100");

                        Label_HRR26_C04.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C04.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C04.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C04.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C04.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C04.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C04.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C04.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C04.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C04.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    case "5":
                        Label_HRR01_C05.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C05.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C05.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C05.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C05.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C05.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C05.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C05.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C05.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C05.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation5 = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C05.Text = HRRation5.ToString("p");
                        Label_HRR12_C05.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C05.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C05.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C05.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C05.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C05.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C05.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C05.Text = BusinessService.decimalParse( Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");

                        Label_HRR20_C05.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C05.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C05.Text = Common.Utilities.GetItemValue(it, "HR01030100");
                        Label_HRR23_C05.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C05.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C05.Text = Common.Utilities.GetItemValue(it, "HR01040100");

                        Label_HRR26_C05.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C05.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C05.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C05.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C05.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C05.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C05.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C05.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C05.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C05.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    case "6":
                        Label_HRR01_C06.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C06.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C06.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C06.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C06.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C06.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C06.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C06.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C06.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C06.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation6 = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C06.Text = HRRation6.ToString("p");
                        Label_HRR12_C06.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C06.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C06.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C06.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C06.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C06.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C06.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C06.Text = BusinessService.decimalParse( Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");

                        Label_HRR20_C06.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C06.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C06.Text = Common.Utilities.GetItemValue(it, "HR01030100");
                        Label_HRR23_C06.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C06.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C06.Text = Common.Utilities.GetItemValue(it, "HR01040100");
                        Label_HRR26_C06.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C06.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C06.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C06.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C06.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C06.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C06.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C06.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C06.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C06.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    case "7":
                        Label_HRR01_C07.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C07.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C07.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C07.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C07.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C07.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C07.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C07.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C07.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C07.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation7 = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C07.Text = HRRation7.ToString("p");
                        Label_HRR12_C07.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C07.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C07.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C07.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C07.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C07.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C07.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C07.Text = BusinessService.decimalParse( Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");
                        Label_HRR20_C07.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C07.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C07.Text = Common.Utilities.GetItemValue(it, "HR01030100");
                        Label_HRR23_C07.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C07.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C07.Text = Common.Utilities.GetItemValue(it, "HR01040100");
                        Label_HRR26_C07.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C07.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C07.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C07.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C07.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C07.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C07.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C07.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C07.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C07.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    case "8":
                        Label_HRR01_C08.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C08.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C08.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C08.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C08.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C08.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C08.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C08.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C08.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C08.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation8 = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C08.Text = HRRation8.ToString("p");
                        Label_HRR12_C08.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C08.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C08.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C08.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C08.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C08.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C08.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C08.Text = BusinessService.decimalParse( Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");
                        Label_HRR20_C08.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C08.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C08.Text = Common.Utilities.GetItemValue(it, "HR01030100");
                        Label_HRR23_C08.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C08.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C08.Text = Common.Utilities.GetItemValue(it, "HR01040100");
                        Label_HRR26_C08.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C08.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C08.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C08.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C08.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C08.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C08.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C08.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C08.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C08.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    case "9":
                        Label_HRR01_C09.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C09.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C09.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C09.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C09.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C09.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C09.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C09.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C09.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C09.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation9 = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C09.Text = HRRation9.ToString("p");
                        Label_HRR12_C09.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C09.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C09.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C09.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C09.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C09.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C09.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C09.Text = BusinessService.decimalParse( Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");
                        Label_HRR20_C09.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C09.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C09.Text = Common.Utilities.GetItemValue(it, "HR01030100");
                        Label_HRR23_C09.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C09.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C09.Text = Common.Utilities.GetItemValue(it, "HR01040100");
                        Label_HRR26_C09.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C09.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C09.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C09.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C09.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C09.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C09.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C09.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C09.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C09.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    case "10":
                        Label_HRR01_C10.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C10.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C10.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C10.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C10.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C10.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C10.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C10.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C10.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C10.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation10 = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C10.Text = HRRation10.ToString("p");
                        Label_HRR12_C10.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C10.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C10.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C10.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C10.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C10.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C10.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C10.Text = BusinessService.decimalParse( Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");
                        Label_HRR20_C10.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C10.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C10.Text = Common.Utilities.GetItemValue(it, "HR01030100");
                        Label_HRR23_C10.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C10.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C10.Text = Common.Utilities.GetItemValue(it, "HR01040100");
                        Label_HRR26_C10.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C10.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C10.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C10.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C10.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C10.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C10.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C10.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C10.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C10.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    case "11":
                        Label_HRR01_C11.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C11.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C11.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C11.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C11.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C11.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C11.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C11.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C11.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C11.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation11 = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C11.Text = HRRation11.ToString("p");
                        Label_HRR12_C11.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C11.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C11.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C11.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C11.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C11.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C11.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C11.Text = BusinessService.decimalParse( Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");
                        Label_HRR20_C11.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C11.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C11.Text = Common.Utilities.GetItemValue(it, "HR01030100");
                        Label_HRR23_C11.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C11.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C11.Text = Common.Utilities.GetItemValue(it, "HR01040100");
                        Label_HRR26_C11.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C11.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C11.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C11.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C11.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C11.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C11.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C11.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C11.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C11.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    case "12":
                        Label_HRR01_C12.Text = Common.Utilities.GetItemValue(it, "HR01010100");
                        Label_HRR02_C12.Text = Common.Utilities.GetItemValue(it, "HR01010101");
                        Label_HRR03_C12.Text = Common.Utilities.GetItemValue(it, "HR01010102");
                        Label_HRR04_C12.Text = Common.Utilities.GetItemValue(it, "HR01010103");
                        Label_HRR05_C12.Text = Common.Utilities.GetItemValue(it, "HR01010104");
                        Label_HRR06_C12.Text = Common.Utilities.GetItemValue(it, "HR01010105");
                        Label_HRR07_C12.Text = Common.Utilities.GetItemValue(it, "HR01010106");
                        Label_HRR08_C12.Text = Common.Utilities.GetItemValue(it, "HR01010200");
                        Label_HRR09_C12.Text = Common.Utilities.GetItemValue(it, "HR01010301");
                        Label_HRR10_C12.Text = Common.Utilities.GetItemValue(it, "HR01010302");
                        //decimal HRRation12 = Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010301")) / Convert.ToDecimal(Common.Utilities.GetItemValue(it, "HR01010302"));
                        //Label_HRR11_C12.Text = HRRation12.ToString("p");
                        Label_HRR12_C12.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020100")).ToString("N1");
                        Label_HRR13_C12.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020101")).ToString("N1");
                        Label_HRR14_C12.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020102")).ToString("N1");
                        Label_HRR15_C12.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020103")).ToString("N1");
                        Label_HRR16_C12.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020104")).ToString("N1");
                        Label_HRR17_C12.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020105")).ToString("N1");
                        Label_HRR18_C12.Text = BusinessService.decimalParse(Common.Utilities.GetItemValue(it, "HR01020106")).ToString("N1");
                        Label_HRR19_C12.Text = BusinessService.decimalParse( Common.Utilities.GetItemValue(it, "HR01020200")).ToString("N1");
                        Label_HRR20_C12.Text = Common.Utilities.GetItemValue(it, "HR01030101");
                        Label_HRR21_C12.Text = Common.Utilities.GetItemValue(it, "HR01030102");
                        Label_HRR22_C12.Text = Common.Utilities.GetItemValue(it, "HR01030100");
                        Label_HRR23_C12.Text = Common.Utilities.GetItemValue(it, "HR01040101");
                        Label_HRR24_C12.Text = Common.Utilities.GetItemValue(it, "HR01040102");
                        Label_HRR25_C12.Text = Common.Utilities.GetItemValue(it, "HR01040100");
                        Label_HRR26_C12.Text = Common.Utilities.GetItemValue(it, "HR01050100");
                        Label_HRR27_C12.Text = Common.Utilities.GetItemValue(it, "HR01060100");
                        Label_HRR28_C12.Text = Common.Utilities.GetItemValue(it, "HR01060101");
                        Label_HRR29_C12.Text = Common.Utilities.GetItemValue(it, "HR01060102");
                        Label_HRR30_C12.Text = Common.Utilities.GetItemValue(it, "HR01070100");
                        Label_HRR31_C12.Text = Common.Utilities.GetItemValue(it, "HR01070101");
                        Label_HRR32_C12.Text = Common.Utilities.GetItemValue(it, "HR01070102");
                        Label_HRR33_C12.Text = Common.Utilities.GetItemValue(it, "HR01080100");
                        Label_HRR34_C12.Text = Common.Utilities.GetItemValue(it, "HR01090100");
                        Label_HRR35_C12.Text = Common.Utilities.GetItemValue(it, "HR01020300");
                        break;
                    default:
                        break;
                }
            }
        }


    }
}
